object fmCustomerLoanPayment: TfmCustomerLoanPayment
  Left = 0
  Top = 0
  Caption = 'Customer Loan Payment'
  ClientHeight = 584
  ClientWidth = 866
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Position = poMainFormCenter
  Visible = True
  OnCloseQuery = FormCloseQuery
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Label13: TLabel
    Left = 17
    Top = 8
    Width = 61
    Height = 13
    Caption = 'Customers'
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Tahoma'
    Font.Style = [fsBold]
    ParentFont = False
  end
  object DBGrid1: TDBGrid
    Left = 17
    Top = 27
    Width = 696
    Height = 120
    DataSource = dsCustomers
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit, dgTitleClick, dgTitleHotTrack]
    TabOrder = 0
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
  end
  object btnClose: TButton
    Left = 764
    Top = 159
    Width = 75
    Height = 25
    Caption = '&Close'
    TabOrder = 1
    OnClick = btnCloseClick
  end
  object btnSave: TButton
    Left = 764
    Top = 128
    Width = 75
    Height = 25
    Caption = '&Save'
    Enabled = False
    TabOrder = 2
  end
  object btnDelete: TButton
    Left = 764
    Top = 97
    Width = 75
    Height = 25
    Caption = '&Delete'
    Enabled = False
    TabOrder = 3
  end
  object btnEdit: TButton
    Left = 764
    Top = 66
    Width = 75
    Height = 25
    Caption = '&Edit'
    Enabled = False
    TabOrder = 4
  end
  object btnNew: TButton
    Left = 764
    Top = 35
    Width = 75
    Height = 25
    Caption = '&New'
    Enabled = False
    TabOrder = 5
  end
  object Panel1: TPanel
    Left = 17
    Top = 153
    Width = 696
    Height = 112
    TabOrder = 6
    object Label1: TLabel
      Left = 33
      Top = 34
      Width = 63
      Height = 13
      Caption = '&Loan Amount'
    end
    object Label3: TLabel
      Left = 216
      Top = 34
      Width = 39
      Height = 13
      Caption = '&Interest'
    end
    object Label4: TLabel
      Left = 560
      Top = 34
      Width = 30
      Height = 13
      Caption = '&Period'
    end
    object Label5: TLabel
      Left = 33
      Top = 61
      Width = 57
      Height = 13
      Caption = 'Period &Type'
    end
    object Label6: TLabel
      Left = 185
      Top = 61
      Width = 70
      Height = 13
      Caption = '&Days of Period'
    end
    object Label7: TLabel
      Left = 337
      Top = 34
      Width = 72
      Height = 13
      Caption = 'Paying &Amount'
    end
    object Label8: TLabel
      Left = 351
      Top = 61
      Width = 58
      Height = 13
      Caption = '&Installments'
    end
    object Label9: TLabel
      Left = 473
      Top = 61
      Width = 117
      Height = 13
      Caption = '&Payment Per Installment'
    end
    object Label10: TLabel
      Left = 33
      Top = 88
      Width = 98
      Height = 13
      Caption = '&Last Period Payment'
    end
    object Label11: TLabel
      Left = 308
      Top = 34
      Width = 11
      Height = 13
      Caption = '%'
    end
    object Label12: TLabel
      Left = 17
      Top = 8
      Width = 71
      Height = 13
      Caption = 'Loan Setting'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'Tahoma'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object DBText1: TDBText
      Left = 111
      Top = 34
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'LOAN_AMOUNT'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText2: TDBText
      Left = 261
      Top = 34
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'INTEREST'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText3: TDBText
      Left = 415
      Top = 34
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'PAYING_AMOUNT'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText4: TDBText
      Left = 608
      Top = 34
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'PERIOD'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText5: TDBText
      Left = 111
      Top = 61
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'PERIOD_TYPE'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText6: TDBText
      Left = 261
      Top = 61
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'DAYS_OF_PERIOD'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText7: TDBText
      Left = 415
      Top = 61
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'INSTALLMENTS'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText8: TDBText
      Left = 608
      Top = 61
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'PAYMENT_PER_INSTALLMENT'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
    object DBText9: TDBText
      Left = 137
      Top = 88
      Width = 41
      Height = 13
      Alignment = taRightJustify
      Color = clWhite
      DataField = 'LAST_PERIOD_PAYMENT'
      DataSource = dsLoanSettings
      ParentColor = False
      Transparent = False
    end
  end
  object DBGrid2: TDBGrid
    Left = 17
    Top = 271
    Width = 696
    Height = 185
    DataSource = dsCustomerLoanPayment
    TabOrder = 7
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'INSTALLMENT_NO'
        Title.Caption = 'Installment No.'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'PAYMENT'
        Title.Caption = 'Payment'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'PAID_AMOUNT'
        Title.Caption = 'Paid Amount'
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'CREATEDATE'
        Title.Caption = 'Payment Date'
        Visible = True
      end>
  end
  object DBNavigator1: TDBNavigator
    Left = 335
    Top = 462
    Width = 378
    Height = 35
    DataSource = dsCustomerLoanPayment
    VisibleButtons = [nbFirst, nbPrior, nbNext, nbLast, nbInsert, nbDelete, nbPost, nbCancel, nbRefresh]
    ParentShowHint = False
    ShowHint = True
    TabOrder = 8
    OnClick = DBNavigator1Click
  end
  object qrySQL: TADQuery
    Connection = ADConnection1
    Left = 776
    Top = 216
  end
  object dsLoanSettings: TDataSource
    DataSet = adtLoanSettings
    Left = 728
    Top = 448
  end
  object adtLoanSettings: TADTable
    Active = True
    Filtered = True
    Filter = 'ACTIVE='#39'Y'#39
    IndexFieldNames = 'CUSTOMER_CODE'
    MasterSource = dsCustomers
    MasterFields = 'CUSTOMER_CODE'
    Connection = ADConnection1
    UpdateOptions.UpdateTableName = 'customerloansettings'
    TableName = 'customerloansettings'
    Left = 816
    Top = 448
  end
  object adtCustomers: TADTable
    Active = True
    IndexFieldNames = 'ID'
    Connection = ADConnection1
    UpdateOptions.UpdateTableName = 'customers'
    TableName = 'customers'
    Left = 816
    Top = 392
  end
  object dsCustomers: TDataSource
    DataSet = adtCustomers
    Left = 728
    Top = 392
  end
  object ADPhysIBDriverLink1: TADPhysIBDriverLink
    DriverID = 'Firebird'
    VendorHome = 'C:\Program Files\Firebird\Firebird_2_5'
    VendorLib = 'fbclient.dll'
    Left = 728
    Top = 336
  end
  object ADPhysMySQLDriverLink1: TADPhysMySQLDriverLink
    Left = 816
    Top = 336
  end
  object ADGUIxWaitCursor1: TADGUIxWaitCursor
    Left = 816
    Top = 280
  end
  object ADConnection1: TADConnection
    Params.Strings = (
      'Database=emarket_mylong'
      'User_Name=emarket_mylong'
      'Password=mylong1117'
      'Server=e-marketkhas.com'
      'DriverID=MySQL')
    ResourceOptions.AssignedValues = [rvAutoReconnect]
    ResourceOptions.AutoReconnect = True
    Connected = True
    LoginPrompt = False
    Left = 728
    Top = 280
  end
  object adtCustomerLoanPayment: TADTable
    Active = True
    IndexFieldNames = 'CUSTOMER_CODE'
    MasterSource = dsLoanSettings
    MasterFields = 'CUSTOMER_CODE'
    Connection = ADConnection1
    UpdateOptions.UpdateTableName = 'customerloanpayment'
    TableName = 'customerloanpayment'
    Left = 728
    Top = 512
  end
  object dsCustomerLoanPayment: TDataSource
    DataSet = adtCustomerLoanPayment
    Left = 816
    Top = 512
  end
end
